package com.ruoyi.project.purchase.mapper;

import com.ruoyi.project.purchase.domain.P_drug;
import com.ruoyi.project.purchase.domain.PurDrugFac;
import com.ruoyi.project.purchase.domain.Purch_drug;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface P_DrugMapper {
    @Select("select drug_type drugType , drug_Rx_type drugRxType from drug GROUP BY drug_type")
    List<P_drug> findType();

    List<P_drug> findAllDrugBy(P_drug p_drug );

    int updateDrugNum(Purch_drug purch_drug);
    List<P_drug> findAll(P_drug p_drug);

    List<PurDrugFac> findAllPurDrugFac(P_drug p_drug);
}
